package com.jhhc.StormSurgeForecast.AstronomicalTide.Dao;

import com.jhhc.StormSurgeForecast.StormSurge.Pojo.FBC.BDMS_FBC_RESULT_A;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface BDMS_FBC_RESULT_AMapper {

    //获取预报格点的计算结果  CSCHEMEID
    List<BDMS_FBC_RESULT_A>  getCalResultsByGrid(@Param("cschemeid") Integer CalSchemeId, @Param("areaName") String AreaName,
                                                 @Param("startTime") String  StartTime,@Param("endTime")
                                                         String EndTime,@Param("dttp") Integer Dttp,@Param("grid") Integer GridId);

    List<BDMS_FBC_RESULT_A> GetDateByGrid(@Param("CSCHEMEID") String CSCHEMEID, @Param("StartTime") String StartTime,
                                          @Param("EndTime") String EndTime, @Param("GRID") String GRID);

    List<BDMS_FBC_RESULT_A> GetDateByGrid2(@Param("CSCHEMEID") String CSCHEMEID, @Param("StartTime") String StartTime,
                                           @Param("EndTime") String EndTime, @Param("GRID") String GRID);

    List<BDMS_FBC_RESULT_A> GetCalResultsByDomain(@Param("CSCHEMEID") String CSCHEMEID,
                                                  @Param("StartTime") String StartTime,
                                                  @Param("EndTime") String EndTime,
                                                  @Param("DTTP") Integer DTTP);

    List<BDMS_FBC_RESULT_A> GetCalResultsByDomainSeaWave(@Param("CSCHEMEID") String CSCHEMEID,
                                                         @Param("DTTP") Integer DTTP);

    List<BDMS_FBC_RESULT_A> GetCalResultsByDomainUV(@Param("CSCHEMEID") String CSCHEMEID,
                                                    @Param("StartTime") String StartTime,
                                                    @Param("EndTime") String EndTime);

    int batchInsert(List<BDMS_FBC_RESULT_A> bdms_fbc_result_as);


    int batchInsert2(BDMS_FBC_RESULT_A bdms_fbc_result_a);


    //根据计算方案编号获取格点数据
    List<BDMS_FBC_RESULT_A> getGridDataBySeaWall(@Param("cschemeid") String CSCHEMEID,
                                                 @Param("grid") String Grid,
                                                 @Param("startTime") String StartTime,
                                                 @Param("endTime") String EndTime,
                                                 @Param("dttp") Integer DTTP);

    int deleteByCschemeId(@Param("cschemeId") String cschemeId);
}

